Client Billing Realization

The Client Billing Realization report is used to see the WIP profitability and analyze historical billing activity in the firm.

Permissions Required for this Report

In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:

• Security group profile > Functional rights > Reports > Shared Library > Shared Views
• Security group profile > Functional rights > Reports > Firm Library > Custom
• Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
• Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
• Security group profile > Functional rights > Reports > Firm Library > <report name>

Note: The Cost column is excluded from the report if the Time Capture > Transaction cost functional right is set to Never Allow.

Reports in Foundation that are Comparable

In Practice Management, the comparable report is Client Billing Realization. In Practice Advantage, the comparable report is Billing Realization using the Client option on the Sort/Subtotal tab.

Report Specifications

The following report options and filters are available to determine the report contents.

Options and Settings
Option	Setting	Description
Hide Comma	Yes/No	Includes or excludes commas in numbers.
Hide Penny	Yes/No	Includes or excludes pennies in amounts.
Hide Details	Yes/No	Includes or excludes details of each transaction. If excluded, only the headers and footers for each group with amounts only for the grand total display in the report. To view a summary amount for each group, select to subtotal the group.
Include Deleted Clients	Yes/No	Includes or excludes deleted client information.

Default Filters
Field Name	Operator	Value
Transaction Date	Between	First Day Of Current Fiscal Year, Last Day Of Current Fiscal Year

Optional Filters
Available Fields
Accounting Period Date	Client Sub ID	Return Group
Business Code	Client Type	Service Code ID
Category ID	Cost	Service Code Name
Category Name	Final Billed	Subcategory ID
Client Bill Manager	Financial Reporting Client Group	Subcategory Name
Client Billing Group	Gross Profit	Tax Type
Client Business Unit	Line of Business	Total Amount
Client ID	Manager	Total Billed
Client ID.Sub ID	Net Progress	Total Hours
Client Name	Posted Date	Transaction Date
Client Office	Primary Partner	Write Up/Down
Client Primary Service Type	Production
Client Region	Real %

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Grouping
Available Fields
Business Code	Client Primary Service Type	Project Office
Category ID	Client Region	Project Region
Category Name	Client Sub ID	Project Type
Client	Client Type	Return Group
Client – Principal	Financial Reporting Client Group	Service Code ID
Client Bill Manager	Line of Business	Service Code Name
Client Billing Group	Manager	Sort Name
Client Business Unit	Primary Partner	Staff ID
Client ID	Project	Staff Name
Client ID.Sub ID	Project Business Unit	Subcategory ID
Client Name	Project ID	Subcategory Name
Client Office	Project Name	Tax Type

Notes:

• The Manager and Primary Partner field names are the default values defined for client responsible staff. Any other client responsible staff List values that are defined for your firm are also listed as available field options.
• When grouping by project-related fields, progress bills are included on a separate line and will display as project data. As an example, when grouping by Project Name, Progress Bill displays as the project name.

Sorting
Available Fields
Client ID	Net Progress	Total Billed
Client Name	Payments	Total Hours
Cost	Production	Write Up/Down
Final Billed	Real %
Gross Profit	Total Amount

Report Fields

The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.

Report Fields
Field	Description
Client ID Sub ID	The client ID and sub-ID (Client ID.Sub-ID).
Client Name	The name of the client.
Total Hours	The total number of hours included on posted invoices for the invoice date within the selected date range.
Total Amount	The total amount of WIP included on posted invoices for the invoice date within the selected date range.
Final Billed	The total WIP amount billed + write up – write down.
Net Progress	The total of progress billed/applied.
Total Billed	The total final billed amount + progress billed – progress applied.
Write Up/Down	The total write up/down amount on billed time amounts.
Real %	The final billed amount divided by the total WIP amount.
Cost	The total cost for each transaction included on the posted invoice.
Gross Profit	The final billed amount minus cost.
Production	The total amount of WIP transactions with a transaction date in the selected date range, regardless of billed status.

Client Billing Realization Sample Report